package com.cndw.kungfu.dao;

import java.util.List;

import com.cndw.dao.jade.annotation.DAO;
import com.cndw.dao.jade.annotation.SQL;
import com.cndw.dao.jade.annotation.SQLParam;

import com.cndw.kungfu.domain.MonsterDeploy;

@DAO
public interface MonsterDeployDao {

	public static final String TABLE = "kfsys_monster_deploy";
	
	public static final String FIELDS = "id,name,sceneId,x,y,defaultMonsterId,monsterIds,storyOnSee,storyOnDead,storyOnTask,refreshApp";
	
	@SQL("select "+FIELDS+" from "+TABLE+" where id=:id ")
	public MonsterDeploy getById(@SQLParam("id") int id);

	
	@SQL("select "+FIELDS+" from "+TABLE+" where sceneId=:sceneId ")
	public List<MonsterDeploy> getBySceneId(@SQLParam("sceneId") int sceneId);
	
	@SQL("select "+FIELDS+" from "+TABLE+" order by id asc ")
	public List<MonsterDeploy> getAllMonsterDeploy();	

}
